/*
	Created: Jonathan Turner
		On : 10/18/2013
Description: Return a hashed password and salt.
	Updates:
*/
ALTER PROCEDURE dbo.GetPasswordInfo @UserName VARCHAR(100)
AS 
  SELECT  PasswordSalt
        , Password
  FROM    dbo.aspnet_Membership AS mem
  INNER JOIN dbo.aspnet_Users AS usr ON mem.UserId = usr.UserId
  WHERE   usr.LoweredUserName = @UserName
GO
